﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>方向条件-按照SQL计算</title>
    <script type="text/javascript" src="../../Scripts/bootstrap/js/jquery.min.js"></script>
    <script type="text/javascript" src="../../Scripts/bootstrap/js/bootstrap.min.js"></script>
    <script src="../../Scripts/QueryString.js" type="text/javascript"></script>
    <script src="../../Scripts/config.js" type="text/javascript"></script>
    <script src="../../Comm/Gener.js" type="text/javascript"></script>
    <link href="../../../DataUser/Style/ccbpm.css" rel="stylesheet" type="text/css" />
    <base target="_self" />
    <script type="text/javascript">

        function Esc() {
            if (event.keyCode == 27)
                window.close();
            return true;
        }

        //初始化页面函数.....
        $(function () {

            var condType = GetQueryString("CondType");
            var fk_flow = GetQueryString("FK_Flow");
            var fk_mainNode = GetQueryString("FK_MainNode");
            var fk_Node = GetQueryString("FK_Node");
            var toNodeID = GetQueryString("ToNodeID");

            var handler = new HttpHandler("BP.WF.HttpHandler.WF_Admin_Cond");
            //            handler.AddUrlData();
            handler.AddPara("FK_Flow", fk_flow);
            handler.AddPara("CondType", condType);
            handler.AddPara("FK_MainNode", fk_mainNode);
            handler.AddPara("FK_Node", fk_Node);
            handler.AddPara("ToNodeID", toNodeID);
            var data = handler.DoMethodReturnString("CondBySQLTemplate_Init");

            //初始化表格.
            //            $.ajax({
            //                type: 'post',
            //                async: true,
            //                url: Handler + "?DoType=CondBySQLTemplate_Init&CondType=" + condType + "&FK_Flow=" + fk_flow + "&FK_MainNode=" + fk_mainNode + "&FK_Node=" + fk_Node + "&ToNodeID=" + toNodeID + "&m=" + Math.random(),
            //                dataType: 'html',
            //                success: function (data) {

            if (data.indexOf('err@') == 0) {
                $("#Msg").html("<font color=red>加载失败:<br>" + data + "</font> .");
                return;
            }

            if (data.indexOf('url@') == 0) {
                var url = data.replace('url@', '');
                window.location.href = url;
                return;
            }

            //转json.
            data = JSON.parse(data);

            var docs = data.OperatorValue;

            //绑定查询.
            GenerBindEntities("DDL_Template", "BP.WF.Template.SQLTemplates", docs, "SQLType=0");
            //document.getElementById("TB_Docs").value = docs;
            document.getElementById("TB_Note").value = data.Note;
            //                }
            //            });
        });

        //执行保存..
        function Save() {

            var condType = GetQueryString("CondType");
            var fk_flow = GetQueryString("FK_Flow");
            var fk_mainNode = GetQueryString("FK_MainNode");
            var fk_Node = GetQueryString("FK_Node");

            var toNodeID = GetQueryString("ToNodeID");
            var sqlVal = $("#DDL_Template").val(); //  document.getElementById("DDL_Template").value;
            var note = document.getElementById("TB_Note").value;

            //            if (sqlVal == "") {
            //                alert('请输入参数.');
            //                return;
            //            }
            if (note == "") {
                alert('请输入备注说明.');
                return;
            }
            var handler = new HttpHandler("BP.WF.HttpHandler.WF_Admin_Cond");
            handler.AddPara("FK_Flow", fk_flow);
            handler.AddPara("CondType", condType);
            handler.AddPara("FK_MainNode", fk_mainNode);
            handler.AddPara("FK_Node", fk_Node);
            handler.AddPara("ToNodeID", toNodeID);
            handler.AddPara("TB_Docs", sqlVal);
            handler.AddPara("TB_Note", note);
            var data = handler.DoMethodReturnString("CondBySQLTemplate_Save");

            if (data.indexOf('err@') == 0) {
                $("#Msg").html("<font color=red>" + data + "</font>");
                return;
            }

            if (data.indexOf('url@') == 0) {
                var url = data.replace('url@', '');
                window.location.href = url;
                return;
            }

            alert(data);

            //$("#Msg").html("<font color=green>" + data + "</font>");

        }

        //执行删除..
        function Delete() {

            if (window.confirm('您确定要删除吗？') == false)
                return;

            var condType = GetQueryString("CondType");
            var fk_flow = GetQueryString("FK_Flow");
            var fk_mainNode = GetQueryString("FK_MainNode");
            var fk_Node = GetQueryString("FK_Node");
            var toNodeID = GetQueryString("ToNodeID");

            var handler = new HttpHandler("BP.WF.HttpHandler.WF_Admin_Cond");
            handler.AddPara("FK_Flow", fk_flow);
            handler.AddPara("CondType", condType);
            handler.AddPara("FK_MainNode", fk_mainNode);
            handler.AddPara("FK_Node", fk_Node);
            handler.AddPara("ToNodeID", toNodeID);
            var data = handler.DoMethodReturnString("CondBySQLTemplate_Delete");


            if (data.indexOf('err@') == 0) {
                $("#Msg").html("<font color=red>" + data + "</font>");
                return;
            }

            if (data.indexOf('url@') == 0) {
                var url = data.replace('url@', '');
                window.location.href = url;
                return;
            }

            alert(data);
            document.getElementById("DDL_Template").value = "";
            document.getElementById("TB_Note").value = "";

        }

        //装载模版.
        function LoadTemplate() {

            //打开方向条件.
            var url = "../SettingTemplate.htm?TemplateType=CondBySQLTemplateTemplate&CondType=2&m=" + Math.random();
            WinOpen(url, 'ss');
        }
        //返回.
        function Back() {
            var url = window.location.href;
            url = url.replace('CondBySQLTemplate.htm', 'List.htm');
            window.location.href = url;
        }
    </script>
</head>
<body onkeypress="Esc();">
    <form id="cc">
    <table style="width: 90%;">
        <caption>
            <a href="javascript:Back();">
                <img src='../../Img/Btn/back.gif'>返回</a> 方向条件-按照SQl</caption>
        <tr>
            <td style="width: 20%;">
                选择一个SQL模版:
            </td>
            <td>
                <select id="DDL_Template" name="DDL_Template">
                </select>
                <!--<textarea rows="4"  style="width:95%;" id="TB_Docs" name="TB_Docs" > </textarea>-->
            </td>
        </tr>
        <tr>
            <td>
                备注(不为空):
            </td>
            <td>
                <input type="text" value="" id="TB_Note" name="TB_Note" style="width: 95%;" />
            </td>
        </tr>
    </table>
    <input type="button" value="保存" onclick="Save()" />
    <input type="button" value="删除" onclick="Delete()" />
    <input type="button" onclick="Back()" value="返回" id="Button2" />
    <div style="text-align: left">
        <h4>
            &nbsp; &nbsp; &nbsp; &nbsp;帮助</h4>
        <ul>
            <ul>
                <li>该功能是为了方便业务人员设置个性化的SQL的条件.</li>
                <li>开发人员把sql条件设置好，起一个容易识别的中文名字，让流程开发人员方便设置于选择使用，点击这里<a href="javascript:WinOpen('/WF/Comm/Search.htm?EnsName=BP.WF.Template.SQLTemplates&SQLType=0')">执行SQL模版设置</a>.</li>
                <li>在文本框里设置一个查询SQL，它返回一行一列。比如: SELECT COUNT(*) AS Num FROM MyTable WHERE NAME='@MyFieldName'。</li>
                <li>该SQL参数支持系统的表达式，什么是ccflow的表达式请查看说明书。</li>
                <li>当前登录信息变量: @WebUser.No, @WebUser.Name, @WebUser.FK_Dept.</li>
                <li>系统就会获取该返回的值把它转化为decimal类型</li>
                <li>如果该值大于零，该条件就是成立的否则不成立。</li>
            </ul>
    </div>
    </form>
    <center>
        <div id="Msg" />
    </center>
</body>
</html>
